QA/Dev Report: March 2024

General Activities

1. LibreOffice 7.6.6 and LibreOffice 24.2.2 were released on March 28
2. Olivier Hallot (TDF) renamed Fontwork to Text along Path in the UI while updating Help, added Help content for ExportAsFixedFormat VBA method and new Calc functions FILTER, SORT and SORTBY and did several cleanups and fixes in Help
3. Rafael Lima made several improvements to Calc’s Solver dialog, improved the visual consistency of the Tabbed UI and added a warning about the need to reload file after changing macro security level
4. Stéphane Guillou (TDF) updated Help content after UI changes and improved the Help page for macro security
5. Alain Romedenne made many improvements to the officehelper Python script for connecting to LibreOffice processes
6. Dione Maddern rewrote the Help page for Calc’s SUMIF function, updated Help for Writer’s View options and did cleanups in Help
7. Gábor Kelemen (allotropia) did many cleanups in the area of includes while improving the script for finding unneeded includes. He also made some Help fixes
8. Pierre F. made many improvements and fixes to Help pages, for example in the areas of regular expressions and Basic
9. Andras Timar (Collabora) made Help build more robust on Windows and made some cleanups in Help regarding translatable strings
10. Laurent Balland updated Grey Elegant Impress template
11. Miklós Vajna (Collabora) improved copying and pasting between Google Sheets and Calc and did many code cleanups and improvements to automated tests
12. Áron Budea, Marco Cecchetti, Gökay Şatır, Pranam Lashkari, Jaume Pujantell and Michael Meeks (Collabora) worked on LOKit used by Collabora Online
13. Gülşah Köse (Collabora) made it so pressing Enter in an empty list item ends the list in Impress
14. Attila Szűcs (Collabora) improved the performance of handling transparent animated GIFs and made it so image placeholders imported from PPTX files do not display text
15. Tomaž Vajngerl (Collabora) did many code cleanups in graphics code
16. Julien Nabet fixed incorrect display of custom page numbers in Sidebar, fixed an issue with duplicating a sheet in Calc causing unwanted axis label to appear in charts and fixed some crashes
17. Andreas Heinisch fixed an issue with saving print ranges to XLS files
18. Xisco Faulí (TDF) made a dozen additions and changes to automated tests and added a script to replace missing fonts in test documents. He also improved SVG support by implementing overflow:visible, switch element and the filters feMerge, feMergeNode, feBlend and feComposite.
19. Michael Stahl (allotropia) made the Curl-based WebDAV content provider more robust
20. Mike Kaganski (Collabora) fixed issues with copying and pasting charts in Calc, fixed an issue causing incorrect closing tags in Writer HTML export, fixed an issue affecting conditional formatting in overlapping cell ranges, made canceling out of Insert Chart dialog more robust in case of multiple views, fixed an issue with picking a connection type in Database Wizard, fixed an issue in the UNO API implementation for text ranges, harmonised the rounding in Calc’s number formatter and ROUND function and made it so index field names can be single characters which is good news for Japanese users
21. Caolán McNamara (Collabora) improved the performance of threaded calculation in Calc, fixed an issue with Calc’s currency selection dropdown in GTK UIs, improved dark mode support and made “Always autocorrect to” more robust. He also fixed crashes and many issues found by static analysers and fuzzers
22. Stephan Bergmann (allotropia) worked on WASM build. He also did many code cleanups and adapted the code to compiler changes
23. Noel Grandin (Collabora) improved loading time for PPTX files with lots of unused master slides, improved loading time for DOCX files with lots of headers and footers, optimised the handling of columns in Calc, improved the speed of print preview with large merged rows in spreadsheets. He also did many code cleanups
24. Justin Luth (Collabora) made the new global config option RecalcOptimalRowHeightMode also work for XLSX files, fixed a crash when trying to overwrite file in read-only directory when its lock file exists, fixed an issue with z-ordering of objects in DOCX files, fixed image placement issues in DOC/DOCX files, made searching backwards for end of paragraph regex work in Writer, fixed an issue causing unwanted toggling of Ordered List button and made it so frame text boundary line in Writer is only shown if display of formatting marks is active
25. Michael Weghorn (TDF) fixed HiDPI scaling with KF6/Qt6 UIs under Wayland and worked on the accessibility features of GTK4 UI
26. Balázs Varga (allotropia) added Excel2021 array functions FILTER, SORT and SORTBY to Calc, fixed issues with chart rendering in XLSX files, improved the performance of Calc’s SUMPRODUCT function and fixed an issue with objects not shown in slideshow in a PPTX file if they have fillstyle or linestyle
27. Patrick Luby (NeoOffice) fixed issues related to the transparency-to-alpha rework, fixed a Skia issue related to a changed default, fixed horizontal swiping and scrolling when using an RTL UI, made it possible to encrypt files with using public GPG keys with unknown Ownertrust on macOS and fixed macOS crashes
28. Jim Raykowski fixed an issue preventing use of keyboard shortcuts when focused into a tab bar element in the Sidebar, fixed an issue with text selection over pages for multi column tables with repeated headings, improved the name display of custom shapes in the Navigator in Impress/Draw and added a UNO API command to set layer of objects in Draw
29. Sarper Akdemir (allotropia) made it so a reload is not required for embedded objects to be disabled
30. Regina Henschel worked on extruded/3D shape support in PPTX files
31. Samuel Mehrbrodt (allotropia) improved the accessibility checker
32. Armin Le Grand (allotropia) continued polishing support for editing Impress slides during presentation and continued the rework of handling attributes and properties
33. Oliver Specht (CIB) made it possible to insert an empty paragraph before an index that is the first element in a Writer document, made Clone Formatting more robust in Impress, added a search field to Gallery and made Cycle Case also work at the end of words
34. Arnaud Versini did some code cleanups and optimisations
35. Heiko Tietze (TDF) made Infobar close buttons easier to hit, made Bullets and Numbering dialog cleaner, improved dark mode support and added a “What’s new?” dialog to be shown on first run of a major version
36. Hossein Nourikhah (TDF) worked on Developers Guide examples and fixed updating hyperlinks in Draw
37. Tibor Nagy (allotropia) fixed an issue with disappearing text in merged Calc cells and fixed a placeholder box being too tall in PPTX files
38. Kurt Nordback finished adding a chart type for “pie-with-remainder-as-another-pie” and fixed an issue where stacked column charts did not show connection lines
39. Taichi Haradaguchi did some cleanups in dialog definition files
40. Vasily Melenchuk (CIB) improved the code for WinAPI FlashWindow() function that alerts the user about an event in an application
41. Hubert Figuière (Collabora) worked on jsdialog used by Collabora Online
42. David Gilbert did code cleanups in PDF import code
43. Jean-Pierre Ledure worked on the ScriptForge library
44. Leonard Sasse did many cleanups in Python files
45. Fridrich Štrba fixed building with Java 8 and autoconf 2.72
46. Vivek Javiya made heading colours dynamic in Calc, allowing for automatic adjustment
47. László Németh fixed hyphenation at stem boundary by adding a new hyphenation option “Compound characters at line end” and implemented hyphenate-keep paragraph property to keep both parts of a hyphenated word within a single page
48. Adlair Cerecedo-Mendez added LibreOffice minor version and CPU architecture to PDF metadata
49. Skyler Grey (Collabora) improved animating of bullets in presentations exported as SVG
50. René Engelhard (Debian) did build fixes

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

468 bugs, 82 of which are enhancements, have been reported by 297 people.

Top 10 Reporters

1. peter josvai ( 20 )
2. Stéphane Guillou (stragu) ( 17 )
3. Rafael Lima ( 12 )
4. Telesto ( 11 )
5. Jeff Fortin Tam ( 10 )
6. Gabor Kelemen (allotropia) ( 9 )
7. prrvchr ( 8 )
8. Michael Otto ( 7 )
9. Kevin Suo ( 6 )
10. Mike Kaganski ( 6 )

Triaged Bugs

469 bugs have been triaged by 73 people.

Top 10 Triagers

1. Stéphane Guillou (stragu) ( 149 )
2. V Stuart Foote ( 29 )
3. m_a_riosv ( 28 )
4. Heiko Tietze ( 22 )
5. Buovjaga ( 20 )
6. Julien Nabet ( 15 )
7. Mike Kaganski ( 15 )
8. Rafael Lima ( 15 )
9. dunguyen ( 14 )
10. ady ( 14 )

Resolution of resolved bugs

429 bugs have been set to RESOLVED.

Check the following sections for more information about bugs resolved as FIXED, WORKSFORME and DUPLICATE.

Fixed Bugs

143 bugs have been fixed by 35 people.

Top 10 Fixers

1. Mike Kaganski ( 12 )
2. Caolán McNamara ( 12 )
3. Julien Nabet ( 8 )
4. Justin Luth ( 7 )
5. Pierre F ( 6 )
6. Xisco Fauli ( 6 )
7. Patrick Luby ( 6 )
8. Rafael Lima ( 6 )
9. Balazs Varga ( 5 )
10. Noel Grandin ( 5 )

List of critical bugs fixed

1. tdf#160036 Selection invisible in a11y High Contrast modes with SKIA/Raster, Skia/Vulkan unaffected ( Thanks to Patrick Luby )
2. tdf#160095 CRASH: using ALT+RETURN twice ( Thanks to Julien Nabet )

List of high severity bugs fixed

1. tdf#142133 Hyperlinks cannot be clicked / interacted with in PDF export of RTF or DOCX files (comment 9) ( Thanks to Xisco Fauli )
2. tdf#152524 macOS: LibreOffice crashes (gpgme / gpgmeio) on macOS 13 Ventura ( Thanks to Patrick Luby )
3. tdf#154863 Crash when moving images around in a multipage table ( Thanks to Matt K )
4. tdf#157258 “Always autocorrect to” deletes the word instead of replacing (affects extensions like Grammalecte, LanguageTool, Antidote) ( Thanks to Caolán McNamara )
5. tdf#159094 FILESAVE PDF Tagged PDF export of media file fails to create PDF ( Thanks to Tibor Nagy )
6. tdf#159373 Crash in: ScTable::HasAttrib(short,long,short,long,HasAttrFlags) ( Thanks to Julien Nabet )
7. tdf#159931 Exported pptx cannot be opened in PowerPoint because a referenced part does not exist ( Thanks to Sarper Akdemir )
8. tdf#160149 CRASH: undoing conditional format ( Thanks to Mike Kaganski )
9. tdf#160184 allow to “Encrypt with GPG key” on save using public keys with unknown Ownertrust ( Thanks to Patrick Luby )
10. tdf#160365 Writer: unable to turn off “text boundaries” for frames / tables ( Thanks to Justin Luth )
11. tdf#83720 PIVOTTABLE: Wrong date format in column field ( Thanks to Tomaž Vajngerl )
12. tdf#93352 UI. RTL: Horizontal scrolling for right-to-left Sheet moves in opposite direction (macOS and Linux) ( Thanks to Patrick Luby )

List of crashes fixed

1. tdf#152524 macOS: LibreOffice crashes (gpgme / gpgmeio) on macOS 13 Ventura ( Thanks to Patrick Luby )
2. tdf#154072 crash / no effect when clicking some dropdown buttons when toolbar overflows ( Thanks to Caolán McNamara )
3. tdf#154863 Crash when moving images around in a multipage table ( Thanks to Matt K )
4. tdf#158344 FILEOPEN DOCX Crash on opening file ( Thanks to Miklos Vajna )
5. tdf#158945 Calc: crash when entering text in a cell ( Thanks to Julien Nabet )
6. tdf#159373 Crash in: ScTable::HasAttrib(short,long,short,long,HasAttrFlags) ( Thanks to Julien Nabet )
7. tdf#159879 Crash when closing “3D View” dialog ( Thanks to Xisco Fauli )
8. tdf#159933 crash when applying Solarize filter to raster image ( Thanks to Noel Grandin )
9. tdf#160095 CRASH: using ALT+RETURN twice ( Thanks to Julien Nabet )
10. tdf#160149 CRASH: undoing conditional format ( Thanks to Mike Kaganski )
11. tdf#160192 CRASH when trying to overwrite file in read-only directory when its lock file exists ( Thanks to Justin Luth )
12. tdf#160222 LibreOffice 7.6.5 – SF_Session RunApplication crash for unknown reason ( Thanks to Jean-Pierre Ledure )
13. tdf#160368 Crash on save after deleting sheet ( Thanks to Caolán McNamara )

List of performance issues fixed

1. tdf#159687 Cutting rows from specific file with whole column references in formula is slow ( Thanks to Balazs Varga )

List of old bugs ( more than 4 years old ) fixed

1. tdf#103068 New Database Wizard gets confused between ODBC and JDBC connection if you backup twice to step 1. ( Thanks to Mike Kaganski )
2. tdf#116156 Python // officehelper.py misbehaves since 5.3.7 ( Thanks to Alain Romedenne )
3. tdf#126464 Remove “Numbering on/off” UNO command ( Thanks to AhmedHamed )
4. tdf#129292 Writer uses the last-used directory for opening and saving files, ignoring the setting in Options > Paths > My Documents ( Thanks to Pierre F )
5. tdf#40244 FILESAVE to ODF formats: read-only location gives wrong error message ( Thanks to Justin Luth )
6. tdf#63259 It should be possible to use shift + F3 case change (cycle case), when cursor is at the beginning or end of a word and not only in the middle ( Thanks to Oliver Specht )
7. tdf#83720 PIVOTTABLE: Wrong date format in column field ( Thanks to Tomaž Vajngerl )
8. tdf#91336 regular expressions list in Help for asterisk or question mark and “zero or” ( Thanks to Pierre F )
9. tdf#93352 UI. RTL: Horizontal scrolling for right-to-left Sheet moves in opposite direction (macOS and Linux) ( Thanks to Patrick Luby )
10. tdf#94535 UI: Cannot open Fontwork dialog to adapt text to connect shape ( Thanks to Olivier Hallot )
11. tdf#99969 COPYING cells containing a chart and pasting as embedded spreadsheet doesn’t copy the data chart (comment 14) ( Thanks to Mike Kaganski )

WORKSFORME bugs

36 bugs have been retested by 22 people.

Top 10 testers

1. Stéphane Guillou (stragu) ( 7 )
2. Julien Nabet ( 4 )
3. steve ( 3 )
4. Buovjaga ( 3 )
5. m_a_riosv ( 3 )
6. ady ( 2 )
7. Eyal Rozenberg ( 1 )
8. Michael Weghorn ( 1 )
9. Leandro Martín Drudi ( 1 )
10. Andreas Heinisch ( 1 )

DUPLICATED bugs

133 bugs have been duplicated by 26 people.

Top 10 testers

1. Stéphane Guillou (stragu) ( 52 )
2. Mike Kaganski ( 17 )
3. V Stuart Foote ( 10 )
4. Rafael Lima ( 7 )
5. m_a_riosv ( 6 )
6. ady ( 6 )
7. Buovjaga ( 5 )
8. Gabor Kelemen (allotropia) ( 4 )
9. Justin L ( 4 )
10. Michael Weghorn ( 3 )

Verified bug fixes

39 bugs have been verified by 15 people.

Top 10 Verifiers

1. Stéphane Guillou (stragu) ( 19 )
2. Gerald Pfeifer ( 3 )
3. Julien Nabet ( 3 )
4. BogdanB ( 2 )
5. Xisco Faulí ( 2 )
6. Eyal Rozenberg ( 1 )
7. Cor Nouws ( 1 )
8. Timur ( 1 )
9. Łukasz ( 1 )
10. steve ( 1 )

Categorized Bugs

373 bugs have been categorized with a metabug by 27 people.

Top 10 Categorizers

1. Stéphane Guillou (stragu) ( 133 )
2. BogdanB ( 58 )
3. Aron Budea ( 39 )
4. V Stuart Foote ( 36 )
5. Jeff Fortin Tam ( 17 )
6. Heiko Tietze ( 16 )
7. Rafael Lima ( 15 )
8. Dieter ( 14 )
9. Piotr Osada ( 7 )
10. Xisco Faulí ( 5 )

Regression Bugs

43 bugs have been set as regressions by 14 people.

Top 10

1. Stéphane Guillou (stragu) ( 13 )
2. Xisco Faulí ( 6 )
3. V Stuart Foote ( 4 )
4. Robert Großkopf ( 4 )
5. raal ( 4 )
6. Tex2002ans ( 2 )
7. ady ( 2 )
8. m_a_riosv ( 2 )
9. Buovjaga ( 1 )
10. Aron Budea ( 1 )

Bisected Bugs

42 bugs have been bisected by 8 people.

Top 10 Bisecters

1. Stéphane Guillou (stragu) ( 17 )
2. raal ( 9 )
3. Aron Budea ( 5 )
4. Xisco Faulí ( 5 )
5. Gabor Kelemen (allotropia) ( 2 )
6. Tex2002ans ( 2 )
7. Timur ( 1 )
8. Buovjaga ( 1 )

 
 

Evolution of Unconfirmed Bugs

Check the current list of unconfirmed bugs here

Evolution of Open Regressions

Check the current list of open regressions here

Evolution of Open bibisectRequests

Check the current list of open bibisectrequests here

Evolution of Highest Priority Bugs

Check the current list of highest priority bugs here

Evolution of High Priority Bugs

Check the current list of high priority bugs here

Thank you all for making Libreoffice rock!
Join us and help to keep LibreOffice super reliable!
Check the Get Involved page out now!